Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) Character String Functions
4) Collections
5) Conversion Functions
6) Cursor
7) Date Timestamp Functions
8) Function Procedure Packages
9) Index
10) Insert Update Delete
11) Introduction
12) Large Objects
13) Linear Regression Functions
14) Miscellaneous Functions
15) Numerical Math Functions
16) Object Oriented
17) PL SQL Data Types
18) PL SQL Operators
19) PL SQL Programming
20) PL SQL Statements
21) Query Select
22) Regular Expressions Functions
23) Sequences
24) Set
25) SQL Data Types
26) SQL PLUS Session Environment
27) Statistical Functions
28) System Packages
29) System Tables Data Dictionary
30) Table
31) Table Joins
32) Transaction
33) Trigger
34) User Privilege
35) View
36) XML

Aggregate Functions
1) AVG(x) gets the average value of x
2) Compare the difference between count() and count(distinct course)
3) Count all employees by evenodd employee id
4) Count column with table alias
5) Count date field value, and calculation
6) Count department and calculate average salary
7) Count distinct column value
8) Count employees in the same department
9) Count() - count(onhand)
10) Count() vs count(column name)
11) COUNT() with null
12) COUNT(1) from a table
13) COUNT(x) gets the number of rows returned by a query
14) Get median salary
15) Greater than average salary
16) Greater than max(salary)
17) GROUP by with NULL value
18) Grouping Rows with the GROUP BY Clause to get some information on those groups of rows
19) Incorrect Usage of Aggregate Function Calls
20) JOIN with AND and aggregate function
21) List employee whose salary is higher than the average salary
22) List the employees whose salary is higher than the average salary with subquery
23) Max and decode function
24) Max(total_price) - min(total_price)
25) MAX(x) gets the maximum values for x
26) MEDIAN(x) returns the median value of x
27) MIN(x) gets the minimum values for x
28) Passes ROWID to COUNT() and gets the number of rows
29) STDDEV(x) get the standard deviation of x
30) Sum column for a certain time period
31) Sum salary group by department number
32) Sum with group by cude
33) Sum with null value
34) Sum() function and having clause
35) SUM(x) adds all the values in x and returns the total
36) Use AVG
37) Use count, sum, avg, median
38) Use MAX() with dates
39) Use MAX() with strings
40) Use MIN() with dates
41) Use MIN() with strings
42) Use the aggregate functions with valid expression
43) Use the DISTINCT keyword to exclude identical values from a group computation
44) Using Aggregate Functions
45) Using an aggregate with the GROUP BY clause to count by city
46) Using avg() function in having clause
47) Using Groups of Rows with Aggregate Functions
48) VARIANCE(x) gets the variance of x
49) Who have the max value
50) You cannot use an aggregate function to limit rows in a WHERE clause